package dasom.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class OracleJDBC {
	protected static String DRV="oracle.jdbc.OracleDriver";
	protected static String URL="jdbc:oracle:thin:@//112.216.253.122:1521/xe";
	protected static String USR="dds889";
	protected static String PWD="dds889";
	
	public static Connection OpenConn() throws ClassNotFoundException, SQLException{
		Connection conn=null;
		Class.forName(DRV);
		conn=DriverManager.getConnection(URL,USR,PWD);		
		return conn;
	}
	
	public static void closeConn(Connection c, PreparedStatement p, ResultSet r){
		if(r != null)try{r.close(); } catch (Exception e){};
		if(p != null)try{p.close(); } catch (Exception e){};
		if(c != null)try{c.close(); } catch (Exception e){};
	}
}
